<?php
/**
 * Created by PhpStorm.
 * User: R.Ice
 * Date: 2018/10/29
 * Time: 16:27
 * name:按照名称查询课程id
 * url:/erpCourse/searchCourseByName
 */

$courseName = $route->bodyParams['courseName'];

$oesid = $route->bodyParams['oesid'];

$sql = "SELECT `oc_id` FROM `art_oa_course` WHERE `oc_name` = '$courseName' AND `is_delete` = 0 AND `oc_oesid`= '$oesid'";

$re=$db->mysqlDB->query($sql);

$rs = array("data" => $re);
//返回成功结果
$response->responseData(true, $rs);